Setting Advanced Linked Server

Connect timeout
Define the time-out value for connecting to a linked server. If 0, use the sp_configure default.

Query timeout
Define the time-out value for queries against a linked server. If 0, use the sp_configure default.

Data Access
Check this option to enable a linked server for distributed query access.

Collation Compatible
If this option is checked, SQL Server assumes that all characters in the linked server are compatible with the local server, with regard to character set and collation sequence (or sort order). This enables SQL Server to send comparisons on character columns to the provider.

Use Remote Collation
If this option is checked, the collation of remote columns is used for SQL Server data sources, and the collation specified in collation name is used for non-SQL Server data sources.

Collation
Specify the name of the collation used by the remote data source if Use Remote Collation is checked and the data source is not a SQL Server data source. The name must be one of the collations supported by SQL Server.

Lazy Schema Validation
If this option is checked, skip schema checking of remote tables at the beginning of the query.

Publisher
Check this option to enable publisher.

Subscriber
Check this option to enable subscriber.

Distributor
Check this option to enable distributor.

RPC
Check this option to enable RPC from the given server.

RPC Out
Check this option to enable RPC to the given server.

Promotion of Distributed Transactions for RPC
Use this option to protect the actions of a server-to-server procedure through a Microsoft Distributed Transaction Coordinator (MS DTC) transaction.

Note: Support from SQL Server 2005 or later.